if exists(select name from sysobjects where name = 'sp_WebGetInfo')
	drop proc sp_WebGetInfo
go
/*-- =============================================
	Created by: HP
	Created on: 2014-04-04 (dd/mm/yyyy)
	Description: 
	--

	File:$sql-scripts/Proc.sp_WebGetInfo.sql
*/-- =============================================

CREATE PROCEDURE sp_WebGetInfo
			
	@Id      		INT
AS
BEGIN	
	SELECT
		a.[Id],
		a.[Ten],
		a.[SiteUrl],
		a.[Url],
		a.[RootDiv],
		a.[NodeName],
		a.[NodeNameAttribute],
		a.[NodeImage],
		a.[NodeImageAttribute],
		a.[NodeLink],
		a.[NodeLinkAttribute],
		a.[NodeGiaNiemYet],
		a.[NodeGiaNiemYetAttribute],
		a.[NodeGiaKM],
		a.[NodeGiaKMAttribute],
		a.[NodeThoiGian],
		a.[NodeThoiGianAttribute],
		a.[NodeNoiDung],
		a.[NodeNoiDungAttribute],
		a.[WebChaId],
		a.LoaiKhuyenMaiId,
		a.thanhpho
	FROM
		Web a
	WHERE
		    a.[Id]       = @Id;
END
GO
